Overview

Brought to you by YData

Dataset statistics

Number of variables	21
Number of observations	27312
Missing cells	94165
Missing cells (%)	16.4%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	4.2 MiB
Average record size in memory	161.0 B

Variable types

Numeric	6
DateTime	2
Categorical	11
Boolean	1
Text	1

Alerts

`BORO` is highly overall correlated with `Latitude` and 4 other fields	High correlation
`INCIDENT_KEY` is highly overall correlated with `LOC_CLASSFCTN_DESC` and 1 other fields	High correlation
`JURISDICTION_CODE` is highly overall correlated with `LOCATION_DESC` and 1 other fields	High correlation
`LOCATION_DESC` is highly overall correlated with `JURISDICTION_CODE` and 1 other fields	High correlation
`LOC_CLASSFCTN_DESC` is highly overall correlated with `INCIDENT_KEY` and 3 other fields	High correlation
`LOC_OF_OCCUR_DESC` is highly overall correlated with `INCIDENT_KEY` and 1 other fields	High correlation
`Latitude` is highly overall correlated with `BORO` and 2 other fields	High correlation
`Longitude` is highly overall correlated with `BORO` and 1 other fields	High correlation
`PERP_AGE_GROUP` is highly overall correlated with `PERP_SEX`	High correlation
`PERP_RACE` is highly overall correlated with `PERP_SEX`	High correlation
`PERP_SEX` is highly overall correlated with `PERP_AGE_GROUP` and 1 other fields	High correlation
`PRECINCT` is highly overall correlated with `BORO` and 2 other fields	High correlation
`X_COORD_CD` is highly overall correlated with `BORO` and 1 other fields	High correlation
`Y_COORD_CD` is highly overall correlated with `BORO` and 2 other fields	High correlation
`JURISDICTION_CODE` is highly imbalanced (58.0%)	Imbalance
`PERP_SEX` is highly imbalanced (60.6%)	Imbalance
`VIC_SEX` is highly imbalanced (71.0%)	Imbalance
`VIC_RACE` is highly imbalanced (52.5%)	Imbalance
`LOC_OF_OCCUR_DESC` has 25596 (93.7%) missing values	Missing
`LOC_CLASSFCTN_DESC` has 25596 (93.7%) missing values	Missing
`LOCATION_DESC` has 14977 (54.8%) missing values	Missing
`PERP_AGE_GROUP` has 9344 (34.2%) missing values	Missing
`PERP_SEX` has 9310 (34.1%) missing values	Missing
`PERP_RACE` has 9310 (34.1%) missing values	Missing

Reproduction

Analysis started	2025-05-28 16:31:48.611369
Analysis finished	2025-05-28 16:32:02.149235
Duration	13.54 seconds
Software version	ydata-profiling vv4.16.1
Download configuration	config.json

INCIDENT_KEY
Real number (ℝ)

High correlation

Distinct	21420
Distinct (%)	78.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1.2086054 × 10⁸

Minimum	9953245
Maximum	2.6119019 × 10⁸
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	213.5 KiB

Quantile statistics

Minimum	9953245
5-th percentile	24224969
Q1	63860880
median	90372218
Q3	1.8881023 × 10⁸
95-th percentile	2.4266957 × 10⁸
Maximum	2.6119019 × 10⁸
Range	2.5123694 × 10⁸
Interquartile range (IQR)	1.2494935 × 10⁸

Descriptive statistics

Standard deviation	73412859
Coefficient of variation (CV)	0.60741795
Kurtosis	-1.2470904
Mean	1.2086054 × 10⁸
Median Absolute Deviation (MAD)	55642069
Skewness	0.34508435
Sum	3.300943 × 10¹²
Variance	5.3894478 × 10¹⁵
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
173354054	18	0.1%
94424905	12	< 0.1%
23749375	12	< 0.1%
138997051	12	< 0.1%
215776333	12	< 0.1%
212640102	12	< 0.1%
72195829	12	< 0.1%
24717013	12	< 0.1%
79378503	12	< 0.1%
33706902	12	< 0.1%
Other values (21410)	27186	99.5%

Value	Count	Frequency (%)
9953245	1	< 0.1%
9953246	1	< 0.1%
9953247	1	< 0.1%
9953248	1	< 0.1%
9953249	1	< 0.1%
9953250	2	< 0.1%
9953252	1	< 0.1%
9953255	2	< 0.1%
9953257	1	< 0.1%
9953258	1	< 0.1%

Value	Count	Frequency (%)
261190187	1	< 0.1%
261176930	1	< 0.1%
261176929	1	< 0.1%
261175635	1	< 0.1%
261160236	1	< 0.1%
261120108	2	< 0.1%
261120017	1	< 0.1%
260637443	4	< 0.1%
260637442	1	< 0.1%
260531774	1	< 0.1%

OCCUR_DATE
Date

Distinct	5761
Distinct (%)	21.1%
Missing	0
Missing (%)	0.0%
Memory size	213.5 KiB

Minimum	2006-01-01 00:00:00
Maximum	2022-12-31 00:00:00
Invalid dates	0
Invalid dates (%)	0.0%

Histogram with fixed size bins (bins=50)

OCCUR_TIME
Date

Distinct	1421
Distinct (%)	5.2%
Missing	0
Missing (%)	0.0%
Memory size	213.5 KiB

Minimum	2025-05-28 00:00:00
Maximum	2025-05-28 23:59:00
Invalid dates	0
Invalid dates (%)	0.0%

Histogram with fixed size bins (bins=50)

BORO
Categorical

High correlation

Distinct	5
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	213.5 KiB

BROOKLYN	10933
BRONX	7937
QUEENS	4094
MANHATTAN	3572
STATEN ISLAND	776

Length

Max length	13
Median length	9
Mean length	7.1012376
Min length	5

Characters and Unicode

Total characters	193949
Distinct characters	19
Distinct categories	2 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	QUEENS
2nd row	BRONX
3rd row	QUEENS
4th row	BRONX
5th row	BRONX

Common Values

Value	Count	Frequency (%)
BROOKLYN	10933	40.0%
BRONX	7937	29.1%
QUEENS	4094	15.0%
MANHATTAN	3572	13.1%
STATEN ISLAND	776	2.8%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
brooklyn	10933	38.9%
bronx	7937	28.3%
queens	4094	14.6%
manhattan	3572	12.7%
staten	776	2.8%
island	776	2.8%

Most occurring characters

Value	Count	Frequency (%)
N	31660	16.3%
O	29803	15.4%
B	18870	9.7%
R	18870	9.7%
A	12268	6.3%
L	11709	6.0%
K	10933	5.6%
Y	10933	5.6%
E	8964	4.6%
T	8696	4.5%
Other values (9)	31243	16.1%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	193173	99.6%
Space Separator	776	0.4%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
N	31660	16.4%
O	29803	15.4%
B	18870	9.8%
R	18870	9.8%
A	12268	6.4%
L	11709	6.1%
K	10933	5.7%
Y	10933	5.7%
E	8964	4.6%
T	8696	4.5%
Other values (8)	30467	15.8%

Space Separator

Value	Count	Frequency (%)
	776	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	193173	99.6%
Common	776	0.4%

Most frequent character per script

Latin

Value	Count	Frequency (%)
N	31660	16.4%
O	29803	15.4%
B	18870	9.8%
R	18870	9.8%
A	12268	6.4%
L	11709	6.1%
K	10933	5.7%
Y	10933	5.7%
E	8964	4.6%
T	8696	4.5%
Other values (8)	30467	15.8%

Common

Value	Count	Frequency (%)
	776	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	193949	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
N	31660	16.3%
O	29803	15.4%
B	18870	9.7%
R	18870	9.7%
A	12268	6.3%
L	11709	6.0%
K	10933	5.6%
Y	10933	5.6%
E	8964	4.6%
T	8696	4.5%
Other values (9)	31243	16.1%

LOC_OF_OCCUR_DESC
Categorical

High correlation Missing

Distinct	2
Distinct (%)	0.1%
Missing	25596
Missing (%)	93.7%
Memory size	213.5 KiB

OUTSIDE	1474
INSIDE	242

Length

Max length	7
Median length	7
Mean length	6.8589744
Min length	6

Characters and Unicode

Total characters	11770
Distinct characters	8
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	OUTSIDE
2nd row	OUTSIDE
3rd row	OUTSIDE
4th row	OUTSIDE
5th row	OUTSIDE

Common Values

Value	Count	Frequency (%)
OUTSIDE	1474	5.4%
INSIDE	242	0.9%
(Missing)	25596	93.7%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
outside	1474	85.9%
inside	242	14.1%

Most occurring characters

Value	Count	Frequency (%)
I	1958	16.6%
S	1716	14.6%
D	1716	14.6%
E	1716	14.6%
T	1474	12.5%
U	1474	12.5%
O	1474	12.5%
N	242	2.1%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	11770	100.0%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
I	1958	16.6%
S	1716	14.6%
D	1716	14.6%
E	1716	14.6%
T	1474	12.5%
U	1474	12.5%
O	1474	12.5%
N	242	2.1%

Most occurring scripts

Value	Count	Frequency (%)
Latin	11770	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
I	1958	16.6%
S	1716	14.6%
D	1716	14.6%
E	1716	14.6%
T	1474	12.5%
U	1474	12.5%
O	1474	12.5%
N	242	2.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	11770	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
I	1958	16.6%
S	1716	14.6%
D	1716	14.6%
E	1716	14.6%
T	1474	12.5%
U	1474	12.5%
O	1474	12.5%
N	242	2.1%

PRECINCT
Real number (ℝ)

High correlation

Distinct	77
Distinct (%)	0.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	65.635362

Minimum	1
Maximum	123
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	213.5 KiB

Quantile statistics

Minimum	1
5-th percentile	25
Q1	44
median	68
Q3	81
95-th percentile	113
Maximum	123
Range	122
Interquartile range (IQR)	37

Descriptive statistics

Standard deviation	27.305705
Coefficient of variation (CV)	0.41602125
Kurtosis	-0.73292236
Mean	65.635362
Median Absolute Deviation (MAD)	22
Skewness	0.21090762
Sum	1792633
Variance	745.60154
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
75	1557	5.7%
73	1452	5.3%
67	1216	4.5%
44	1020	3.7%
79	1012	3.7%
47	953	3.5%
40	908	3.3%
46	895	3.3%
42	850	3.1%
113	802	2.9%
Other values (67)	16647	61.0%

Value	Count	Frequency (%)
1	25	0.1%
5	58	0.2%
6	28	0.1%
7	109	0.4%
9	109	0.4%
10	73	0.3%
13	60	0.2%
14	56	0.2%
17	10	< 0.1%
18	34	0.1%

Value	Count	Frequency (%)
123	31	0.1%
122	61	0.2%
121	112	0.4%
120	572	2.1%
115	179	0.7%
114	369	1.4%
113	802	2.9%
112	23	0.1%
111	11	< 0.1%
110	160	0.6%

JURISDICTION_CODE
Categorical

High correlation Imbalance

Distinct	3
Distinct (%)	< 0.1%
Missing	2
Missing (%)	< 0.1%
Memory size	213.5 KiB

0.0	22809
2.0	4427
1.0	74

Length

Max length	3
Median length	3
Mean length	3
Min length	3

Characters and Unicode

Total characters	81930
Distinct characters	4
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0.0
2nd row	0.0
3rd row	0.0
4th row	0.0
5th row	0.0

Common Values

Value	Count	Frequency (%)
0.0	22809	83.5%
2.0	4427	16.2%
1.0	74	0.3%
(Missing)	2	< 0.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
0.0	22809	83.5%
2.0	4427	16.2%
1.0	74	0.3%

Most occurring characters

Value	Count	Frequency (%)
0	50119	61.2%
.	27310	33.3%
2	4427	5.4%
1	74	0.1%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	54620	66.7%
Other Punctuation	27310	33.3%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	50119	91.8%
2	4427	8.1%
1	74	0.1%

Other Punctuation

Value	Count	Frequency (%)
.	27310	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	81930	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	50119	61.2%
.	27310	33.3%
2	4427	5.4%
1	74	0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	81930	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	50119	61.2%
.	27310	33.3%
2	4427	5.4%
1	74	0.1%

LOC_CLASSFCTN_DESC
Categorical

High correlation Missing

Distinct	9
Distinct (%)	0.5%
Missing	25596
Missing (%)	93.7%
Memory size	213.5 KiB

STREET	1103
HOUSING	280
DWELLING	127
COMMERCIAL	100
OTHER	31
Other values (4)	75

Length

Max length	11
Median length	6
Mean length	6.6386946
Min length	5

Characters and Unicode

Total characters	11392
Distinct characters	21
Distinct categories	2 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	STREET
2nd row	STREET
3rd row	STREET
4th row	STREET
5th row	STREET

Common Values

Value	Count	Frequency (%)
STREET	1103	4.0%
HOUSING	280	1.0%
DWELLING	127	0.5%
COMMERCIAL	100	0.4%
OTHER	31	0.1%
PLAYGROUND	30	0.1%
VEHICLE	23	0.1%
TRANSIT	15	0.1%
PARKING LOT	7	< 0.1%
(Missing)	25596	93.7%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
street	1103	64.0%
housing	280	16.3%
dwelling	127	7.4%
commercial	100	5.8%
other	31	1.8%
playground	30	1.7%
vehicle	23	1.3%
transit	15	0.9%
parking	7	0.4%
lot	7	0.4%

Most occurring characters

Value	Count	Frequency (%)
E	2510	22.0%
T	2274	20.0%
S	1398	12.3%
R	1286	11.3%
I	552	4.8%
N	459	4.0%
O	448	3.9%
G	444	3.9%
L	414	3.6%
H	334	2.9%
Other values (11)	1273	11.2%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	11385	99.9%
Space Separator	7	0.1%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
E	2510	22.0%
T	2274	20.0%
S	1398	12.3%
R	1286	11.3%
I	552	4.8%
N	459	4.0%
O	448	3.9%
G	444	3.9%
L	414	3.6%
H	334	2.9%
Other values (10)	1266	11.1%

Space Separator

Value	Count	Frequency (%)
	7	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	11385	99.9%
Common	7	0.1%

Most frequent character per script

Latin

Value	Count	Frequency (%)
E	2510	22.0%
T	2274	20.0%
S	1398	12.3%
R	1286	11.3%
I	552	4.8%
N	459	4.0%
O	448	3.9%
G	444	3.9%
L	414	3.6%
H	334	2.9%
Other values (10)	1266	11.1%

Common

Value	Count	Frequency (%)
	7	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	11392	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
E	2510	22.0%
T	2274	20.0%
S	1398	12.3%
R	1286	11.3%
I	552	4.8%
N	459	4.0%
O	448	3.9%
G	444	3.9%
L	414	3.6%
H	334	2.9%
Other values (11)	1273	11.2%

LOCATION_DESC
Categorical

High correlation Missing

Distinct	40
Distinct (%)	0.3%
Missing	14977
Missing (%)	54.8%
Memory size	213.5 KiB

MULTI DWELL - PUBLIC HOUS	4832
MULTI DWELL - APT BUILD	2835
(null)	977
PVT HOUSE	951
GROCERY/BODEGA	694
Other values (35)	2046

Length

Max length	25
Median length	23
Mean length	19.263802
Min length	3

Characters and Unicode

Total characters	237619
Distinct characters	33
Distinct categories	7 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	7 ?
Unique (%)	0.1%

Sample

1st row	MULTI DWELL - APT BUILD
2nd row	MULTI DWELL - PUBLIC HOUS
3rd row	GROCERY/BODEGA
4th row	MULTI DWELL - PUBLIC HOUS
5th row	MULTI DWELL - PUBLIC HOUS

Common Values

Value	Count	Frequency (%)
MULTI DWELL - PUBLIC HOUS	4832	17.7%
MULTI DWELL - APT BUILD	2835	10.4%
(null)	977	3.6%
PVT HOUSE	951	3.5%
GROCERY/BODEGA	694	2.5%
BAR/NIGHT CLUB	628	2.3%
COMMERCIAL BLDG	292	1.1%
RESTAURANT/DINER	204	0.7%
NONE	175	0.6%
BEAUTY/NAIL SALON	112	0.4%
Other values (30)	635	2.3%
(Missing)	14977	54.8%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
multi	7667	16.8%
dwell	7667	16.8%
	7667	16.8%
public	4832	10.6%
hous	4832	10.6%
apt	2835	6.2%
build	2835	6.2%
null	977	2.1%
pvt	951	2.1%
house	951	2.1%
Other values (50)	4344	9.5%

Most occurring characters

Value	Count	Frequency (%)
	33223	14.0%
L	32783	13.8%
U	22312	9.4%
I	17099	7.2%
T	13357	5.6%
D	11934	5.0%
E	11525	4.9%
B	10110	4.3%
P	8788	3.7%
O	8669	3.6%
Other values (23)	67819	28.5%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	189067	79.6%
Space Separator	33223	14.0%
Dash Punctuation	7667	3.2%
Lowercase Letter	3908	1.6%
Other Punctuation	1800	0.8%
Open Punctuation	977	0.4%
Close Punctuation	977	0.4%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
L	32783	17.3%
U	22312	11.8%
I	17099	9.0%
T	13357	7.1%
D	11934	6.3%
E	11525	6.1%
B	10110	5.3%
P	8788	4.6%
O	8669	4.6%
M	8408	4.4%
Other values (14)	44082	23.3%

Lowercase Letter

Value	Count	Frequency (%)
l	1954	50.0%
u	977	25.0%
n	977	25.0%

Other Punctuation

Value	Count	Frequency (%)
/	1789	99.4%
.	11	0.6%

Space Separator

Value	Count	Frequency (%)
	33223	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	7667	100.0%

Open Punctuation

Value	Count	Frequency (%)
(	977	100.0%

Close Punctuation

Value	Count	Frequency (%)
)	977	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	192975	81.2%
Common	44644	18.8%

Most frequent character per script

Latin

Value	Count	Frequency (%)
L	32783	17.0%
U	22312	11.6%
I	17099	8.9%
T	13357	6.9%
D	11934	6.2%
E	11525	6.0%
B	10110	5.2%
P	8788	4.6%
O	8669	4.5%
M	8408	4.4%
Other values (17)	47990	24.9%

Common

Value	Count	Frequency (%)
	33223	74.4%
-	7667	17.2%
/	1789	4.0%
(	977	2.2%
)	977	2.2%
.	11	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	237619	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
	33223	14.0%
L	32783	13.8%
U	22312	9.4%
I	17099	7.2%
T	13357	5.6%
D	11934	5.0%
E	11525	4.9%
B	10110	4.3%
P	8788	3.7%
O	8669	3.6%
Other values (23)	67819	28.5%

STATISTICAL_MURDER_FLAG
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	26.8 KiB

False	22046
True	5266

Value	Count	Frequency (%)
False	22046	80.7%
True	5266	19.3%

PERP_AGE_GROUP
Categorical

High correlation Missing

Distinct	10
Distinct (%)	0.1%
Missing	9344
Missing (%)	34.2%
Memory size	213.5 KiB

18-24	6222
25-44	5687
UNKNOWN	3148
<18	1591
(null)	640
Other values (5)	680

Length

Max length	7
Median length	5
Mean length	5.2019702
Min length	3

Characters and Unicode

Total characters	93469
Distinct characters	21
Distinct categories	7 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	3 ?
Unique (%)	< 0.1%

Sample

1st row	25-44
2nd row	25-44
3rd row	25-44
4th row	UNKNOWN
5th row	UNKNOWN

Common Values

Value	Count	Frequency (%)
18-24	6222	22.8%
25-44	5687	20.8%
UNKNOWN	3148	11.5%
<18	1591	5.8%
(null)	640	2.3%
45-64	617	2.3%
65+	60	0.2%
940	1	< 0.1%
224	1	< 0.1%
1020	1	< 0.1%
(Missing)	9344	34.2%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
18-24	6222	34.6%
25-44	5687	31.7%
unknown	3148	17.5%
18	1591	8.9%
null	640	3.6%
45-64	617	3.4%
65	60	0.3%
940	1	< 0.1%
224	1	< 0.1%
1020	1	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
4	18832	20.1%
-	12526	13.4%
2	11912	12.7%
N	9444	10.1%
1	7814	8.4%
8	7813	8.4%
5	6364	6.8%
U	3148	3.4%
K	3148	3.4%
O	3148	3.4%
Other values (11)	9320	10.0%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	53416	57.1%
Uppercase Letter	22036	23.6%
Dash Punctuation	12526	13.4%
Lowercase Letter	2560	2.7%
Math Symbol	1651	1.8%
Open Punctuation	640	0.7%
Close Punctuation	640	0.7%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
4	18832	35.3%
2	11912	22.3%
1	7814	14.6%
8	7813	14.6%
5	6364	11.9%
6	677	1.3%
0	3	< 0.1%
9	1	< 0.1%

Uppercase Letter

Value	Count	Frequency (%)
N	9444	42.9%
U	3148	14.3%
K	3148	14.3%
O	3148	14.3%
W	3148	14.3%

Lowercase Letter

Value	Count	Frequency (%)
l	1280	50.0%
u	640	25.0%
n	640	25.0%

Math Symbol

Value	Count	Frequency (%)
<	1591	96.4%
+	60	3.6%

Dash Punctuation

Value	Count	Frequency (%)
-	12526	100.0%

Open Punctuation

Value	Count	Frequency (%)
(	640	100.0%

Close Punctuation

Value	Count	Frequency (%)
)	640	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	68873	73.7%
Latin	24596	26.3%

Most frequent character per script

Common

Value	Count	Frequency (%)
4	18832	27.3%
-	12526	18.2%
2	11912	17.3%
1	7814	11.3%
8	7813	11.3%
5	6364	9.2%
<	1591	2.3%
6	677	1.0%
(	640	0.9%
)	640	0.9%
Other values (3)	64	0.1%

Latin

Value	Count	Frequency (%)
N	9444	38.4%
U	3148	12.8%
K	3148	12.8%
O	3148	12.8%
W	3148	12.8%
l	1280	5.2%
u	640	2.6%
n	640	2.6%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	93469	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
4	18832	20.1%
-	12526	13.4%
2	11912	12.7%
N	9444	10.1%
1	7814	8.4%
8	7813	8.4%
5	6364	6.8%
U	3148	3.4%
K	3148	3.4%
O	3148	3.4%
Other values (11)	9320	10.0%

PERP_SEX
Categorical

High correlation Imbalance Missing

Distinct	4
Distinct (%)	< 0.1%
Missing	9310
Missing (%)	34.1%
Memory size	213.5 KiB

M	15439
U	1499
(null)	640
F	424

Length

Max length	6
Median length	1
Mean length	1.177758
Min length	1

Characters and Unicode

Total characters	21202
Distinct characters	8
Distinct categories	4 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	M
2nd row	M
3rd row	M
4th row	U
5th row	U

Common Values

Value	Count	Frequency (%)
M	15439	56.5%
U	1499	5.5%
(null)	640	2.3%
F	424	1.6%
(Missing)	9310	34.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
m	15439	85.8%
u	1499	8.3%
null	640	3.6%
f	424	2.4%

Most occurring characters

Value	Count	Frequency (%)
M	15439	72.8%
U	1499	7.1%
l	1280	6.0%
(	640	3.0%
n	640	3.0%
u	640	3.0%
)	640	3.0%
F	424	2.0%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	17362	81.9%
Lowercase Letter	2560	12.1%
Open Punctuation	640	3.0%
Close Punctuation	640	3.0%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
M	15439	88.9%
U	1499	8.6%
F	424	2.4%

Lowercase Letter

Value	Count	Frequency (%)
l	1280	50.0%
n	640	25.0%
u	640	25.0%

Open Punctuation

Value	Count	Frequency (%)
(	640	100.0%

Close Punctuation

Value	Count	Frequency (%)
)	640	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	19922	94.0%
Common	1280	6.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
M	15439	77.5%
U	1499	7.5%
l	1280	6.4%
n	640	3.2%
u	640	3.2%
F	424	2.1%

Common

Value	Count	Frequency (%)
(	640	50.0%
)	640	50.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	21202	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
M	15439	72.8%
U	1499	7.1%
l	1280	6.0%
(	640	3.0%
n	640	3.0%
u	640	3.0%
)	640	3.0%
F	424	2.0%

PERP_RACE
Categorical

High correlation Missing

Distinct	8
Distinct (%)	< 0.1%
Missing	9310
Missing (%)	34.1%
Memory size	213.5 KiB

BLACK	11432
WHITE HISPANIC	2341
UNKNOWN	1836
BLACK HISPANIC	1314
(null)	640
Other values (3)	439

Length

Max length	30
Median length	5
Mean length	7.2321409
Min length	5

Characters and Unicode

Total characters	130193
Distinct characters	27
Distinct categories	6 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	BLACK
2nd row	BLACK
3rd row	BLACK
4th row	UNKNOWN
5th row	UNKNOWN

Common Values

Value	Count	Frequency (%)
BLACK	11432	41.9%
WHITE HISPANIC	2341	8.6%
UNKNOWN	1836	6.7%
BLACK HISPANIC	1314	4.8%
(null)	640	2.3%
WHITE	283	1.0%
ASIAN / PACIFIC ISLANDER	154	0.6%
AMERICAN INDIAN/ALASKAN NATIVE	2	< 0.1%
(Missing)	9310	34.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
black	12746	57.6%
hispanic	3655	16.5%
white	2624	11.9%
unknown	1836	8.3%
null	640	2.9%
asian	154	0.7%
	154	0.7%
pacific	154	0.7%
islander	154	0.7%
american	2	< 0.1%
Other values (2)	4	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
A	17031	13.1%
C	16711	12.8%
K	14584	11.2%
L	12902	9.9%
B	12746	9.8%
I	10558	8.1%
N	9481	7.3%
H	6279	4.8%
W	4460	3.4%
	4121	3.2%
Other values (17)	21320	16.4%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	122076	93.8%
Space Separator	4121	3.2%
Lowercase Letter	2560	2.0%
Open Punctuation	640	0.5%
Close Punctuation	640	0.5%
Other Punctuation	156	0.1%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
A	17031	14.0%
C	16711	13.7%
K	14584	11.9%
L	12902	10.6%
B	12746	10.4%
I	10558	8.6%
N	9481	7.8%
H	6279	5.1%
W	4460	3.7%
S	3965	3.2%
Other values (10)	13359	10.9%

Lowercase Letter

Value	Count	Frequency (%)
l	1280	50.0%
n	640	25.0%
u	640	25.0%

Space Separator

Value	Count	Frequency (%)
	4121	100.0%

Open Punctuation

Value	Count	Frequency (%)
(	640	100.0%

Close Punctuation

Value	Count	Frequency (%)
)	640	100.0%

Other Punctuation

Value	Count	Frequency (%)
/	156	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	124636	95.7%
Common	5557	4.3%

Most frequent character per script

Latin

Value	Count	Frequency (%)
A	17031	13.7%
C	16711	13.4%
K	14584	11.7%
L	12902	10.4%
B	12746	10.2%
I	10558	8.5%
N	9481	7.6%
H	6279	5.0%
W	4460	3.6%
S	3965	3.2%
Other values (13)	15919	12.8%

Common

Value	Count	Frequency (%)
	4121	74.2%
(	640	11.5%
)	640	11.5%
/	156	2.8%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	130193	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
A	17031	13.1%
C	16711	12.8%
K	14584	11.2%
L	12902	9.9%
B	12746	9.8%
I	10558	8.1%
N	9481	7.3%
H	6279	4.8%
W	4460	3.4%
	4121	3.2%
Other values (17)	21320	16.4%

VIC_AGE_GROUP
Categorical

Distinct	7
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	213.5 KiB

25-44	12281
18-24	10086
<18	2839
45-64	1863
65+	181
Other values (2)	62

Length

Max length	7
Median length	5
Mean length	4.7832821
Min length	3

Characters and Unicode

Total characters	130641
Distinct characters	15
Distinct categories	4 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	1 ?
Unique (%)	< 0.1%

Sample

1st row	18-24
2nd row	18-24
3rd row	25-44
4th row	<18
5th row	45-64

Common Values

Value	Count	Frequency (%)
25-44	12281	45.0%
18-24	10086	36.9%
<18	2839	10.4%
45-64	1863	6.8%
65+	181	0.7%
UNKNOWN	61	0.2%
1022	1	< 0.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
25-44	12281	45.0%
18-24	10086	36.9%
18	2839	10.4%
45-64	1863	6.8%
65	181	0.7%
unknown	61	0.2%
1022	1	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
4	38374	29.4%
-	24230	18.5%
2	22369	17.1%
5	14325	11.0%
1	12926	9.9%
8	12925	9.9%
<	2839	2.2%
6	2044	1.6%
N	183	0.1%
+	181	0.1%
Other values (5)	245	0.2%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	102964	78.8%
Dash Punctuation	24230	18.5%
Math Symbol	3020	2.3%
Uppercase Letter	427	0.3%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
4	38374	37.3%
2	22369	21.7%
5	14325	13.9%
1	12926	12.6%
8	12925	12.6%
6	2044	2.0%
0	1	< 0.1%

Uppercase Letter

Value	Count	Frequency (%)
N	183	42.9%
U	61	14.3%
K	61	14.3%
O	61	14.3%
W	61	14.3%

Math Symbol

Value	Count	Frequency (%)
<	2839	94.0%
+	181	6.0%

Dash Punctuation

Value	Count	Frequency (%)
-	24230	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	130214	99.7%
Latin	427	0.3%

Most frequent character per script

Common

Value	Count	Frequency (%)
4	38374	29.5%
-	24230	18.6%
2	22369	17.2%
5	14325	11.0%
1	12926	9.9%
8	12925	9.9%
<	2839	2.2%
6	2044	1.6%
+	181	0.1%
0	1	< 0.1%

Latin

Value	Count	Frequency (%)
N	183	42.9%
U	61	14.3%
K	61	14.3%
O	61	14.3%
W	61	14.3%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	130641	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
4	38374	29.4%
-	24230	18.5%
2	22369	17.1%
5	14325	11.0%
1	12926	9.9%
8	12925	9.9%
<	2839	2.2%
6	2044	1.6%
N	183	0.1%
+	181	0.1%
Other values (5)	245	0.2%

VIC_SEX
Categorical

Imbalance

Distinct	3
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	213.5 KiB

M	24686
F	2615
U	11

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	27312
Distinct characters	3
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	M
2nd row	M
3rd row	M
4th row	M
5th row	M

Common Values

Value	Count	Frequency (%)
M	24686	90.4%
F	2615	9.6%
U	11	< 0.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
m	24686	90.4%
f	2615	9.6%
u	11	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
M	24686	90.4%
F	2615	9.6%
U	11	< 0.1%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	27312	100.0%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
M	24686	90.4%
F	2615	9.6%
U	11	< 0.1%

Most occurring scripts

Value	Count	Frequency (%)
Latin	27312	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
M	24686	90.4%
F	2615	9.6%
U	11	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	27312	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
M	24686	90.4%
F	2615	9.6%
U	11	< 0.1%

VIC_RACE
Categorical

Imbalance

Distinct	7
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	213.5 KiB

BLACK	19439
WHITE HISPANIC	4049
BLACK HISPANIC	2646
WHITE	698
ASIAN / PACIFIC ISLANDER	404
Other values (2)	76

Length

Max length	30
Median length	5
Mean length	7.5012083
Min length	5

Characters and Unicode

Total characters	204873
Distinct characters	22
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	BLACK
2nd row	BLACK
3rd row	WHITE
4th row	WHITE HISPANIC
5th row	BLACK

Common Values

Value	Count	Frequency (%)
BLACK	19439	71.2%
WHITE HISPANIC	4049	14.8%
BLACK HISPANIC	2646	9.7%
WHITE	698	2.6%
ASIAN / PACIFIC ISLANDER	404	1.5%
UNKNOWN	66	0.2%
AMERICAN INDIAN/ALASKAN NATIVE	10	< 0.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
black	22085	62.7%
hispanic	6695	19.0%
white	4747	13.5%
asian	404	1.1%
	404	1.1%
pacific	404	1.1%
islander	404	1.1%
unknown	66	0.2%
american	10	< 0.1%
indian/alaskan	10	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
A	30466	14.9%
C	29598	14.4%
L	22499	11.0%
K	22161	10.8%
B	22085	10.8%
I	19793	9.7%
H	11442	5.6%
	7927	3.9%
N	7751	3.8%
S	7513	3.7%
Other values (12)	23638	11.5%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	196532	95.9%
Space Separator	7927	3.9%
Other Punctuation	414	0.2%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
A	30466	15.5%
C	29598	15.1%
L	22499	11.4%
K	22161	11.3%
B	22085	11.2%
I	19793	10.1%
H	11442	5.8%
N	7751	3.9%
S	7513	3.8%
P	7099	3.6%
Other values (10)	16125	8.2%

Space Separator

Value	Count	Frequency (%)
	7927	100.0%

Other Punctuation

Value	Count	Frequency (%)
/	414	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	196532	95.9%
Common	8341	4.1%

Most frequent character per script

Latin

Value	Count	Frequency (%)
A	30466	15.5%
C	29598	15.1%
L	22499	11.4%
K	22161	11.3%
B	22085	11.2%
I	19793	10.1%
H	11442	5.8%
N	7751	3.9%
S	7513	3.8%
P	7099	3.6%
Other values (10)	16125	8.2%

Common

Value	Count	Frequency (%)
	7927	95.0%
/	414	5.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	204873	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
A	30466	14.9%
C	29598	14.4%
L	22499	11.0%
K	22161	10.8%
B	22085	10.8%
I	19793	9.7%
H	11442	5.6%
	7927	3.9%
N	7751	3.8%
S	7513	3.7%
Other values (12)	23638	11.5%

X_COORD_CD
Real number (ℝ)

High correlation

Distinct	12088
Distinct (%)	44.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1009448.7

Minimum	914928.06
Maximum	1066815.4
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	213.5 KiB

Quantile statistics

Minimum	914928.06
5-th percentile	985316.88
Q1	1000028.5
median	1007730.7
Q3	1016838
95-th percentile	1046384.1
Maximum	1066815.4
Range	151887.31
Interquartile range (IQR)	16809.469

Descriptive statistics

Standard deviation	18377.826
Coefficient of variation (CV)	0.018205805
Kurtosis	2.4771539
Mean	1009448.7
Median Absolute Deviation (MAD)	8096.7188
Skewness	-0.11683797
Sum	2.7570062 × 10¹⁰
Variance	3.3774448 × 10⁸
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1017119.438	66	0.2%
1026387	47	0.2%
1008276	47	0.2%
936721.6875	44	0.2%
1017141	44	0.2%
1006434	42	0.2%
1046405	41	0.2%
1008427.438	40	0.1%
998032	39	0.1%
1046367	37	0.1%
Other values (12078)	26865	98.4%

Value	Count	Frequency (%)
914928.0625	1	< 0.1%
920262.5625	1	< 0.1%
920515.3125	1	< 0.1%
922416.3125	1	< 0.1%
922884.1875	1	< 0.1%
925479.75	1	< 0.1%
926453.875	1	< 0.1%
926731	1	< 0.1%
927599.375	1	< 0.1%
929510	1	< 0.1%

Value	Count	Frequency (%)
1066815.375	1	< 0.1%
1066516.5	4	< 0.1%
1065539.625	2	< 0.1%
1065473.75	1	< 0.1%
1063056	1	< 0.1%
1062381	1	< 0.1%
1061286.375	1	< 0.1%
1060126.375	1	< 0.1%
1059864.875	1	< 0.1%
1059828	1	< 0.1%

Y_COORD_CD
Real number (ℝ)

High correlation

Distinct	12283
Distinct (%)	45.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	208127.4

Minimum	125756.72
Maximum	271127.69
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	213.5 KiB

Quantile statistics

Minimum	125756.72
5-th percentile	162476
Q1	182834.34
median	194486.57
Q3	239518.47
95-th percentile	256184.25
Maximum	271127.69
Range	145370.97
Interquartile range (IQR)	56684.133

Descriptive statistics

Standard deviation	31886.378
Coefficient of variation (CV)	0.15320605
Kurtosis	-1.3627973
Mean	208127.4
Median Absolute Deviation (MAD)	22944.477
Skewness	0.1665039
Sum	5.6843756 × 10⁹
Variance	1.0167411 × 10⁹
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
183909.3438	66	0.2%
183623	47	0.2%
262634	47	0.2%
172119.4375	44	0.2%
183798	44	0.2%
244344	42	0.2%
187112.6406	41	0.2%
183517.7188	40	0.1%
175598	38	0.1%
186986	37	0.1%
Other values (12273)	26866	98.4%

Value	Count	Frequency (%)
125756.7188	1	< 0.1%
127539	1	< 0.1%
128875.4141	1	< 0.1%
129721	1	< 0.1%
130418.4922	1	< 0.1%
131549	1	< 0.1%
132099.3438	1	< 0.1%
134246.7656	4	< 0.1%
134459	1	< 0.1%
135831.5156	1	< 0.1%

Value	Count	Frequency (%)
271127.6875	2	< 0.1%
269635	4	< 0.1%
269534	1	< 0.1%
269204.8438	4	< 0.1%
269204	1	< 0.1%
269168.625	4	< 0.1%
269115.625	7	< 0.1%
269040	1	< 0.1%
268978	1	< 0.1%
268961	1	< 0.1%

Latitude
Real number (ℝ)

High correlation

Distinct	12619
Distinct (%)	46.2%
Missing	10
Missing (%)	< 0.1%
Infinite	0
Infinite (%)	0.0%
Mean	40.737892

Minimum	40.511586
Maximum	40.910818
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	213.5 KiB

Quantile statistics

Minimum	40.511586
5-th percentile	40.612606
Q1	40.668481
median	40.700318
Q3	40.824067
95-th percentile	40.869836
Maximum	40.910818
Range	0.39923252
Interquartile range (IQR)	0.15558556

Descriptive statistics

Standard deviation	0.08752512
Coefficient of variation (CV)	0.0021484941
Kurtosis	-1.3631852
Mean	40.737892
Median Absolute Deviation (MAD)	0.062822439
Skewness	0.16654804
Sum	1112225.9
Variance	0.0076606466
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
40.67141261	66	0.2%
40.67065507	47	0.2%
40.88745131	47	0.2%
40.67110691	44	0.2%
40.63898538	44	0.2%
40.83732351	42	0.2%
40.68004774	41	0.2%
40.67036569	40	0.1%
40.64865009	38	0.1%
40.67970041	37	0.1%
Other values (12609)	26856	98.3%

Value	Count	Frequency (%)
40.51158557	1	< 0.1%
40.516572	1	< 0.1%
40.52018586	1	< 0.1%
40.52258031	1	< 0.1%
40.52443658	1	< 0.1%
40.527587	1	< 0.1%
40.52910801	1	< 0.1%
40.53500878	4	< 0.1%
40.535616	1	< 0.1%
40.53929753	1	< 0.1%

Value	Count	Frequency (%)
40.91081809	2	< 0.1%
40.90666838	4	< 0.1%
40.90639492	1	< 0.1%
40.90548733	4	< 0.1%
40.905479	1	< 0.1%
40.90538927	4	< 0.1%
40.90523864	7	< 0.1%
40.90503636	1	< 0.1%
40.904861	1	< 0.1%
40.9048145	1	< 0.1%

Longitude
Real number (ℝ)

High correlation

Distinct	12607
Distinct (%)	46.2%
Missing	10
Missing (%)	< 0.1%
Infinite	0
Infinite (%)	0.0%
Mean	-73.909051

Minimum	-74.249303
Maximum	-73.702046
Zeros	0
Zeros (%)	0.0%
Negative	27302
Negative (%)	> 99.9%
Memory size	213.5 KiB

Quantile statistics

Minimum	-74.249303
5-th percentile	-73.996196
Q1	-73.943027
median	-73.915221
Q3	-73.88233
95-th percentile	-73.775916
Maximum	-73.702046
Range	0.54725733
Interquartile range (IQR)	0.060697446

Descriptive statistics

Standard deviation	0.066272257
Coefficient of variation (CV)	-0.00089667309
Kurtosis	2.4669825
Mean	-73.909051
Median Absolute Deviation (MAD)	0.029296094
Skewness	-0.11919338
Sum	-2017864.9
Variance	0.0043920121
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
-73.88151014	66	0.2%
-73.84760779	47	0.2%
-73.91339092	47	0.2%
-73.88143296	44	0.2%
-74.17125343	44	0.2%
-73.91983076	42	0.2%
-73.7759092	41	0.2%
-73.91284539	40	0.1%
-73.95033556	38	0.1%
-73.77604737	37	0.1%
Other values (12597)	26856	98.3%

Value	Count	Frequency (%)
-74.2493035	1	< 0.1%
-74.23014863	1	< 0.1%
-74.22932911	1	< 0.1%
-74.22241624	1	< 0.1%
-74.22078238	1	< 0.1%
-74.21146347	1	< 0.1%
-74.2079657	1	< 0.1%
-74.20699897	1	< 0.1%
-74.20383785	1	< 0.1%
-74.196874	1	< 0.1%

Value	Count	Frequency (%)
-73.70204617	1	< 0.1%
-73.70308024	4	< 0.1%
-73.70659811	2	< 0.1%
-73.70686575	1	< 0.1%
-73.71563826	1	< 0.1%
-73.71803289	1	< 0.1%
-73.72199603	1	< 0.1%
-73.72653339	1	< 0.1%
-73.72739037	1	< 0.1%
-73.727478	1	< 0.1%

Lon_Lat
Text

Distinct	12645
Distinct (%)	46.3%
Missing	10
Missing (%)	< 0.1%
Memory size	213.5 KiB

Length

Max length	45
Median length	44
Mean length	43.270676
Min length	24

Characters and Unicode

Total characters	1181376
Distinct characters	20
Distinct categories	7 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	7665 ?
Unique (%)	28.1%

Sample

1st row	POINT (-73.73083868899994 40.662964620000025)
2nd row	POINT (-73.92494232599995 40.81035186300006)
3rd row	POINT (-73.91549174199997 40.74260663300004)
4th row	POINT (-73.91945661499994 40.83778200300003)
5th row	POINT (-73.85290950899997 40.88623791800006)

Value	Count	Frequency (%)
point	27302	33.3%
73.88151014499994	66	0.1%
40.67141260500006	66	0.1%
73.84760778699996	47	0.1%
40.670655072000045	47	0.1%
73.91339091999998	47	0.1%
40.88745131300004	47	0.1%
40.67110691100004	44	0.1%
73.88143295699996	44	0.1%
74.17125343299995	44	0.1%
Other values (25238)	54152	66.1%

Most occurring characters

Value	Count	Frequency (%)
0	173561	14.7%
9	162366	13.7%
7	85042	7.2%
4	82827	7.0%
3	74639	6.3%
8	67516	5.7%
6	67117	5.7%
5	55260	4.7%
	54604	4.6%
.	54604	4.6%
Other values (10)	303840	25.7%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	853752	72.3%
Uppercase Letter	136510	11.6%
Space Separator	54604	4.6%
Other Punctuation	54604	4.6%
Open Punctuation	27302	2.3%
Dash Punctuation	27302	2.3%
Close Punctuation	27302	2.3%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	173561	20.3%
9	162366	19.0%
7	85042	10.0%
4	82827	9.7%
3	74639	8.7%
8	67516	7.9%
6	67117	7.9%
5	55260	6.5%
1	42924	5.0%
2	42500	5.0%

Uppercase Letter

Value	Count	Frequency (%)
N	27302	20.0%
I	27302	20.0%
O	27302	20.0%
P	27302	20.0%
T	27302	20.0%

Space Separator

Value	Count	Frequency (%)
	54604	100.0%

Other Punctuation

Value	Count	Frequency (%)
.	54604	100.0%

Open Punctuation

Value	Count	Frequency (%)
(	27302	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	27302	100.0%

Close Punctuation

Value	Count	Frequency (%)
)	27302	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	1044866	88.4%
Latin	136510	11.6%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	173561	16.6%
9	162366	15.5%
7	85042	8.1%
4	82827	7.9%
3	74639	7.1%
8	67516	6.5%
6	67117	6.4%
5	55260	5.3%
	54604	5.2%
.	54604	5.2%
Other values (5)	167330	16.0%

Latin

Value	Count	Frequency (%)
N	27302	20.0%
I	27302	20.0%
O	27302	20.0%
P	27302	20.0%
T	27302	20.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	1181376	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	173561	14.7%
9	162366	13.7%
7	85042	7.2%
4	82827	7.0%
3	74639	6.3%
8	67516	5.7%
6	67117	5.7%
5	55260	4.7%
	54604	4.6%
.	54604	4.6%
Other values (10)	303840	25.7%

Interactions

Correlations

	BORO	INCIDENT_KEY	JURISDICTION_CODE	LOCATION_DESC	LOC_CLASSFCTN_DESC	LOC_OF_OCCUR_DESC	Latitude	Longitude	PERP_AGE_GROUP	PERP_RACE	PERP_SEX	PRECINCT	STATISTICAL_MURDER_FLAG	VIC_AGE_GROUP	VIC_RACE	VIC_SEX	X_COORD_CD	Y_COORD_CD
BORO	1.000	0.037	0.077	0.162	0.116	0.084	0.603	0.717	0.047	0.135	0.033	0.890	0.013	0.023	0.149	0.011	0.717	0.603
INCIDENT_KEY	0.037	1.000	0.046	0.287	1.000	1.000	0.034	0.011	0.258	0.242	0.365	-0.035	0.017	0.060	0.037	0.017	0.011	0.034
JURISDICTION_CODE	0.077	0.046	1.000	0.637	0.927	0.150	0.128	0.116	0.052	0.060	0.000	0.141	0.034	0.033	0.069	0.000	0.114	0.127
LOCATION_DESC	0.162	0.287	0.637	1.000	0.520	0.460	0.125	0.122	0.164	0.178	0.246	0.136	0.137	0.076	0.129	0.048	0.122	0.125
LOC_CLASSFCTN_DESC	0.116	1.000	0.927	0.520	1.000	0.641	0.122	0.136	0.139	0.094	0.131	0.102	0.202	0.062	0.115	0.082	0.134	0.121
LOC_OF_OCCUR_DESC	0.084	1.000	0.150	0.460	0.641	1.000	0.099	0.058	0.190	0.085	0.058	0.055	0.097	0.084	0.033	0.086	0.062	0.094
Latitude	0.603	0.034	0.128	0.125	0.122	0.099	1.000	0.262	0.036	0.139	0.035	-0.556	0.020	0.031	0.157	0.022	0.260	1.000
Longitude	0.717	0.011	0.116	0.122	0.136	0.058	0.262	1.000	0.036	0.099	0.024	0.184	0.023	0.033	0.110	0.006	1.000	0.262
PERP_AGE_GROUP	0.047	0.258	0.052	0.164	0.139	0.190	0.036	0.036	1.000	0.456	0.683	0.037	0.214	0.155	0.060	0.072	0.036	0.036
PERP_RACE	0.135	0.242	0.060	0.178	0.094	0.085	0.139	0.099	0.456	1.000	0.770	0.107	0.133	0.049	0.244	0.031	0.099	0.139
PERP_SEX	0.033	0.365	0.000	0.246	0.131	0.058	0.035	0.024	0.683	0.770	1.000	0.035	0.101	0.049	0.038	0.030	0.024	0.035
PRECINCT	0.890	-0.035	0.141	0.136	0.102	0.055	-0.556	0.184	0.037	0.107	0.035	1.000	0.015	0.026	0.130	0.020	0.185	-0.556
STATISTICAL_MURDER_FLAG	0.013	0.017	0.034	0.137	0.202	0.097	0.020	0.023	0.214	0.133	0.101	0.015	1.000	0.089	0.048	0.005	0.024	0.019
VIC_AGE_GROUP	0.023	0.060	0.033	0.076	0.062	0.084	0.031	0.033	0.155	0.049	0.049	0.026	0.089	1.000	0.119	0.161	0.033	0.031
VIC_RACE	0.149	0.037	0.069	0.129	0.115	0.033	0.157	0.110	0.060	0.244	0.038	0.130	0.048	0.119	1.000	0.186	0.109	0.156
VIC_SEX	0.011	0.017	0.000	0.048	0.082	0.086	0.022	0.006	0.072	0.031	0.030	0.020	0.005	0.161	0.186	1.000	0.007	0.022
X_COORD_CD	0.717	0.011	0.114	0.122	0.134	0.062	0.260	1.000	0.036	0.099	0.024	0.185	0.024	0.033	0.109	0.007	1.000	0.261
Y_COORD_CD	0.603	0.034	0.127	0.125	0.121	0.094	1.000	0.262	0.036	0.139	0.035	-0.556	0.019	0.031	0.156	0.022	0.261	1.000

Missing values

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

Sample

	INCIDENT_KEY	OCCUR_DATE	OCCUR_TIME	BORO	LOC_OF_OCCUR_DESC	PRECINCT	LOC_CLASSFCTN_DESC	LOCATION_DESC	STATISTICAL_MURDER_FLAG	PERP_AGE_GROUP	PERP_SEX	PERP_RACE	VIC_AGE_GROUP	VIC_SEX	VIC_RACE	X_COORD_CD	Y_COORD_CD	Latitude	Longitude	Lon_Lat
0	228798151	05/27/2021	21:30:00	QUEENS	NaN	105	NaN	NaN	False	NaN	NaN	NaN	18-24	M	BLACK	1.058925e+06	180924.000000	40.662965	-73.730839	POINT (-73.73083868899994 40.662964620000025)
1	137471050	06/27/2014	17:40:00	BRONX	NaN	40	NaN	NaN	False	NaN	NaN	NaN	18-24	M	BLACK	1.005028e+06	234516.000000	40.810352	-73.924942	POINT (-73.92494232599995 40.81035186300006)
2	147998800	11/21/2015	03:56:00	QUEENS	NaN	108	NaN	NaN	True	NaN	NaN	NaN	25-44	M	WHITE	1.007668e+06	209836.531250	40.742607	-73.915492	POINT (-73.91549174199997 40.74260663300004)
3	146837977	10/09/2015	18:30:00	BRONX	NaN	44	NaN	NaN	False	NaN	NaN	NaN	<18	M	WHITE HISPANIC	1.006537e+06	244511.140625	40.837782	-73.919457	POINT (-73.91945661499994 40.83778200300003)
4	58921844	02/19/2009	22:58:00	BRONX	NaN	47	NaN	NaN	True	25-44	M	BLACK	45-64	M	BLACK	1.024922e+06	262189.406250	40.886238	-73.852910	POINT (-73.85290950899997 40.88623791800006)
5	219559682	10/21/2020	21:36:00	BROOKLYN	NaN	81	NaN	NaN	True	NaN	NaN	NaN	25-44	M	BLACK	1.004234e+06	186461.703125	40.678457	-73.927952	POINT (-73.92795224099996 40.678456718000064)
6	85295722	06/17/2012	22:47:00	QUEENS	NaN	114	NaN	NaN	False	NaN	NaN	NaN	25-44	M	BLACK	9.988600e+05	214885.000000	40.756482	-73.947266	POINT (-73.94726649399996 40.75648234300007)
7	71662474	03/08/2010	19:41:00	BROOKLYN	NaN	81	NaN	NaN	True	NaN	NaN	NaN	18-24	M	BLACK	1.002883e+06	192219.703125	40.694264	-73.932809	POINT (-73.93280863699994 40.694264056000065)
8	83002139	02/05/2012	05:45:00	QUEENS	NaN	105	NaN	NaN	False	NaN	NaN	NaN	25-44	M	BLACK	1.054366e+06	196628.406250	40.706107	-73.747107	POINT (-73.74710653899996 40.706106731000034)
9	86437261	08/26/2012	01:10:00	QUEENS	NaN	101	NaN	MULTI DWELL - APT BUILD	False	25-44	M	BLACK	25-44	M	BLACK	1.053937e+06	157130.421875	40.597697	-73.749065	POINT (-73.74906464199995 40.59769719800005)

	INCIDENT_KEY	OCCUR_DATE	OCCUR_TIME	BORO	LOC_OF_OCCUR_DESC	PRECINCT	JURISDICTION_CODE	LOC_CLASSFCTN_DESC	LOCATION_DESC	STATISTICAL_MURDER_FLAG	PERP_AGE_GROUP	PERP_SEX	PERP_RACE	VIC_AGE_GROUP	VIC_SEX	VIC_RACE	X_COORD_CD	Y_COORD_CD	Latitude	Longitude	Lon_Lat
27302	243566423	04/12/2022	19:43:00	BRONX	OUTSIDE	48	0.0	STREET	(null)	False	18-24	M	BLACK	45-64	M	BLACK	1016397.0	247394.0	40.845658	-73.883806	POINT (-73.883806 40.845658)
27303	249978889	08/23/2022	01:58:00	BROOKLYN	OUTSIDE	88	0.0	STREET	(null)	False	25-44	M	BLACK	<18	M	BLACK	991912.0	191839.0	40.693229	-73.972367	POINT (-73.972367 40.693229)
27304	246999028	06/22/2022	05:28:00	BRONX	OUTSIDE	41	0.0	STREET	(null)	False	25-44	M	BLACK	25-44	M	BLACK	1015533.0	238047.0	40.820006	-73.886973	POINT (-73.886973 40.820006)
27305	248475917	07/23/2022	15:03:00	QUEENS	OUTSIDE	110	0.0	STREET	(null)	False	45-64	M	WHITE HISPANIC	25-44	M	BLACK HISPANIC	1022651.0	212300.0	40.749308	-73.861406	POINT (-73.86140607 40.74930759)
27306	245173597	05/16/2022	16:50:00	BRONX	OUTSIDE	41	0.0	STREET	BEAUTY/NAIL SALON	True	18-24	M	BLACK	<18	F	WHITE HISPANIC	1012932.0	238907.0	40.822374	-73.896369	POINT (-73.896369 40.822374)
27307	245029823	05/14/2022	03:02:00	BRONX	OUTSIDE	48	0.0	STREET	(null)	False	(null)	(null)	(null)	18-24	M	BLACK	1011526.0	247828.0	40.846864	-73.901413	POINT (-73.90141321 40.84686352)
27308	239583450	01/22/2022	13:15:00	MANHATTAN	OUTSIDE	30	0.0	STREET	(null)	False	25-44	F	WHITE HISPANIC	25-44	M	WHITE HISPANIC	997458.0	240485.0	40.826743	-73.952273	POINT (-73.952273 40.826743)
27309	246825728	06/18/2022	03:29:00	MANHATTAN	OUTSIDE	32	0.0	STREET	(null)	False	18-24	M	BLACK	25-44	M	BLACK	1000999.0	234464.0	40.810209	-73.939496	POINT (-73.9394955 40.81020941)
27310	246876579	06/19/2022	20:08:00	BRONX	INSIDE	46	2.0	HOUSING	MULTI DWELL - PUBLIC HOUS	False	25-44	M	BLACK	25-44	M	WHITE HISPANIC	1012980.0	251028.0	40.855644	-73.896141	POINT (-73.896141 40.855644)
27311	239861542	01/28/2022	18:14:00	BRONX	OUTSIDE	45	0.0	STREET	(null)	False	18-24	M	BLACK	18-24	M	BLACK	1026549.0	244293.0	40.837102	-73.847134	POINT (-73.847134 40.837102)

Overview

Variables

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Uppercase Letter

Space Separator

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Uppercase Letter

Most occurring scripts

Most frequent character per script

Latin

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Other Punctuation

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Uppercase Letter

Space Separator

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Uppercase Letter

Lowercase Letter

Other Punctuation

Space Separator

Dash Punctuation

Open Punctuation

Close Punctuation

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length